﻿
/****** Object:  Trigger dbo.TRG_TestWebCustomer2    Script Date: 10/14/2009 10:39:08 PM ******/
CREATE TRIGGER TRG_TestWebCustomer2 ON [dbo].[tblWebCustomer] 
FOR Update 
AS
insert into tblSendMail ( recipients, subject, message )
select 'MEmerson@vitalbasics.com', 'updated WebCustomer',
	'CustomerNumber = ' + cast( T1.CustomerNumber as varchar ) + ', WebUserID = ' + cast( T1.WebUserID  as varchar ) +
	' to CustomerNumber = ' + cast( T2.CustomerNumber as varchar ) + ', WebUserID = ' + cast( T2.WebUserID  as varchar )
from inserted T1, deleted T2


